/*
 Navicat Premium Data Transfer

 Source Server         : sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 10504000
 Source Host           : LAPTOP-8GQJMQNU\SQLEXPRESS:1433
 Source Catalog        : B
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 10504000
 File Encoding         : 65001

 Date: 04/07/2020 12:43:01
*/


-- ----------------------------
-- Table structure for Articles
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Articles]') AND type IN ('U'))
	DROP TABLE [dbo].[Articles]
GO

CREATE TABLE [dbo].[Articles] (
  [Id] int NOT NULL,
  [Title] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [CreatedTime] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [Author] varchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[Articles] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Articles]
-- ----------------------------
INSERT INTO [dbo].[Articles]  VALUES (N'18', N'添加测试2', N'2020-07-04 上午 11:55:48', N'admin')
GO

INSERT INTO [dbo].[Articles]  VALUES (N'23', N'sdfsdf', N'2020-07-04 下午 12:42:28', N'admin')
GO


-- ----------------------------
-- Table structure for Users
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND type IN ('U'))
	DROP TABLE [dbo].[Users]
GO

CREATE TABLE [dbo].[Users] (
  [Id] int NOT NULL,
  [Username] varchar(255) COLLATE Chinese_PRC_CI_AS NULL,
  [Password] varchar(255) COLLATE Chinese_PRC_CI_AS NULL
)
GO

ALTER TABLE [dbo].[Users] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of [Users]
-- ----------------------------
INSERT INTO [dbo].[Users]  VALUES (N'1', N'admin', N'admin')
GO

INSERT INTO [dbo].[Users]  VALUES (N'2', N'zeng', N'123456')
GO

INSERT INTO [dbo].[Users]  VALUES (N'3', N'wang', N'123456')
GO

INSERT INTO [dbo].[Users]  VALUES (N'4', N'zheng', N'123456')
GO


-- ----------------------------
-- Primary Key structure for table Articles
-- ----------------------------
ALTER TABLE [dbo].[Articles] ADD CONSTRAINT [PK__Articles__3214EC077F60ED59] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table Users
-- ----------------------------
ALTER TABLE [dbo].[Users] ADD CONSTRAINT [PK__Users__3214EC0703317E3D] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF)  
ON [PRIMARY]
GO

